Implementing Campaign Manager - External Integrations


JSON decoder plugin

Use the JSON decoder plugin to automatically parse a column containing JSON objects. The objects are broken into named fields and are discarded if they lack certain fields or contain forbidden ones.

Many sources of data use JSON (Java Script Object Notation) as a way of encoding their data. There are a number of tools in Kettle that can be used to read and parse JSON, but all of them require extensive configuration which is tedious and error prone.

This transform step is used to automatically parse a column containing JSON objects. The objects are broken into named fields. Specific JSON objects are discarded when they lack certain fields or have forbidden ones in them.

The plugin in this directory must be added to a script that runs in an open-source ETL package called Kettle. There are three ways of running the scripts:

  1. With a user interface, using a Kettle application called 'Spoon'. Spoon allows you to edit and debug the scripts.
  2. From a command line, using a Kettle application called 'Kitchen'.
  3. From another Kettle script using the 'Job' step.

  Online & Instructor-Led Courses | Training Videos | Webinar Recordings
© Alterian. All Rights Reserved. | Privacy Policy | Legal Notice